************************************************
***Title: wind_clean.do
***Creators: Joelle Abramowitz, Shooshan Danagoulian, and Owen Fleming*
***Notes: This cleans the wind data and constructs a county-date panel.

*For questions, contact
*Owen Fleming
*hg3490@wayne.edu
************************************************


**********SETUP
cd ${path}/data/wind
clear all
set more off

	
**********IMPORT AND CLEAN
*simple cleaning
use wind_1997_2023, clear
format date %td
drop lat lon latitude longitude
rename fips county

*remove certain states (this is actually not necessary)
gen state = floor(county/1000)
drop if state==2
drop if state==15
drop if state==72
drop state


**********SAVE
save wind, replace


**********REVERT DIRECTORY
cd ${path}

